﻿


  
using System;
using SubSonic;
using SubSonic.Schema;
using SubSonic.DataProviders;
using System.Data;

namespace ModelQLKS.Model{
	public partial class QLKSDB{

        public StoredProcedure dt_addtosourcecontrol(string vchSourceSafeINI,string vchProjectName,string vchComment,string vchLoginName,string vchPassword){
            StoredProcedure sp=new StoredProcedure("dt_addtosourcecontrol",this.Provider);
            sp.Command.AddParameter("vchSourceSafeINI",vchSourceSafeINI,DbType.AnsiString);
            sp.Command.AddParameter("vchProjectName",vchProjectName,DbType.AnsiString);
            sp.Command.AddParameter("vchComment",vchComment,DbType.AnsiString);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.AnsiString);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_addtosourcecontrol_u(string vchSourceSafeINI,string vchProjectName,string vchComment,string vchLoginName,string vchPassword){
            StoredProcedure sp=new StoredProcedure("dt_addtosourcecontrol_u",this.Provider);
            sp.Command.AddParameter("vchSourceSafeINI",vchSourceSafeINI,DbType.String);
            sp.Command.AddParameter("vchProjectName",vchProjectName,DbType.String);
            sp.Command.AddParameter("vchComment",vchComment,DbType.String);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.String);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.String);
            return sp;
        }
        public StoredProcedure dt_adduserobject(){
            StoredProcedure sp=new StoredProcedure("dt_adduserobject",this.Provider);
            return sp;
        }
        public StoredProcedure dt_adduserobject_vcs(string vchProperty){
            StoredProcedure sp=new StoredProcedure("dt_adduserobject_vcs",this.Provider);
            sp.Command.AddParameter("vchProperty",vchProperty,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_checkinobject(string chObjectType,string vchObjectName,string vchComment,string vchLoginName,string vchPassword,int iVCSFlags,int iActionFlag,string txStream1,string txStream2,string txStream3){
            StoredProcedure sp=new StoredProcedure("dt_checkinobject",this.Provider);
            sp.Command.AddParameter("chObjectType",chObjectType,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("vchObjectName",vchObjectName,DbType.AnsiString);
            sp.Command.AddParameter("vchComment",vchComment,DbType.AnsiString);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.AnsiString);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.AnsiString);
            sp.Command.AddParameter("iVCSFlags",iVCSFlags,DbType.Int32);
            sp.Command.AddParameter("iActionFlag",iActionFlag,DbType.Int32);
            sp.Command.AddParameter("txStream1",txStream1,DbType.AnsiString);
            sp.Command.AddParameter("txStream2",txStream2,DbType.AnsiString);
            sp.Command.AddParameter("txStream3",txStream3,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_checkinobject_u(string chObjectType,string vchObjectName,string vchComment,string vchLoginName,string vchPassword,int iVCSFlags,int iActionFlag,string txStream1,string txStream2,string txStream3){
            StoredProcedure sp=new StoredProcedure("dt_checkinobject_u",this.Provider);
            sp.Command.AddParameter("chObjectType",chObjectType,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("vchObjectName",vchObjectName,DbType.String);
            sp.Command.AddParameter("vchComment",vchComment,DbType.String);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.String);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.String);
            sp.Command.AddParameter("iVCSFlags",iVCSFlags,DbType.Int32);
            sp.Command.AddParameter("iActionFlag",iActionFlag,DbType.Int32);
            sp.Command.AddParameter("txStream1",txStream1,DbType.AnsiString);
            sp.Command.AddParameter("txStream2",txStream2,DbType.AnsiString);
            sp.Command.AddParameter("txStream3",txStream3,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_checkoutobject(string chObjectType,string vchObjectName,string vchComment,string vchLoginName,string vchPassword,int iVCSFlags,int iActionFlag){
            StoredProcedure sp=new StoredProcedure("dt_checkoutobject",this.Provider);
            sp.Command.AddParameter("chObjectType",chObjectType,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("vchObjectName",vchObjectName,DbType.AnsiString);
            sp.Command.AddParameter("vchComment",vchComment,DbType.AnsiString);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.AnsiString);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.AnsiString);
            sp.Command.AddParameter("iVCSFlags",iVCSFlags,DbType.Int32);
            sp.Command.AddParameter("iActionFlag",iActionFlag,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_checkoutobject_u(string chObjectType,string vchObjectName,string vchComment,string vchLoginName,string vchPassword,int iVCSFlags,int iActionFlag){
            StoredProcedure sp=new StoredProcedure("dt_checkoutobject_u",this.Provider);
            sp.Command.AddParameter("chObjectType",chObjectType,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("vchObjectName",vchObjectName,DbType.String);
            sp.Command.AddParameter("vchComment",vchComment,DbType.String);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.String);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.String);
            sp.Command.AddParameter("iVCSFlags",iVCSFlags,DbType.Int32);
            sp.Command.AddParameter("iActionFlag",iActionFlag,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_displayoaerror(int iObject,int iresult){
            StoredProcedure sp=new StoredProcedure("dt_displayoaerror",this.Provider);
            sp.Command.AddParameter("iObject",iObject,DbType.Int32);
            sp.Command.AddParameter("iresult",iresult,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_displayoaerror_u(int iObject,int iresult){
            StoredProcedure sp=new StoredProcedure("dt_displayoaerror_u",this.Provider);
            sp.Command.AddParameter("iObject",iObject,DbType.Int32);
            sp.Command.AddParameter("iresult",iresult,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_droppropertiesbyid(int id,string property){
            StoredProcedure sp=new StoredProcedure("dt_droppropertiesbyid",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_dropuserobjectbyid(int id){
            StoredProcedure sp=new StoredProcedure("dt_dropuserobjectbyid",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_generateansiname(string name){
            StoredProcedure sp=new StoredProcedure("dt_generateansiname",this.Provider);
            sp.Command.AddParameter("name",name,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_getobjwithprop(string property,string value){
            StoredProcedure sp=new StoredProcedure("dt_getobjwithprop",this.Provider);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            sp.Command.AddParameter("value",value,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_getobjwithprop_u(string property,string uvalue){
            StoredProcedure sp=new StoredProcedure("dt_getobjwithprop_u",this.Provider);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            sp.Command.AddParameter("uvalue",uvalue,DbType.String);
            return sp;
        }
        public StoredProcedure dt_getpropertiesbyid(int id,string property){
            StoredProcedure sp=new StoredProcedure("dt_getpropertiesbyid",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_getpropertiesbyid_u(int id,string property){
            StoredProcedure sp=new StoredProcedure("dt_getpropertiesbyid_u",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_getpropertiesbyid_vcs(int id,string property,string value){
            StoredProcedure sp=new StoredProcedure("dt_getpropertiesbyid_vcs",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            sp.Command.AddParameter("value",value,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_getpropertiesbyid_vcs_u(int id,string property,string value){
            StoredProcedure sp=new StoredProcedure("dt_getpropertiesbyid_vcs_u",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            sp.Command.AddParameter("value",value,DbType.String);
            return sp;
        }
        public StoredProcedure dt_isundersourcecontrol(string vchLoginName,string vchPassword,int iWhoToo){
            StoredProcedure sp=new StoredProcedure("dt_isundersourcecontrol",this.Provider);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.AnsiString);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.AnsiString);
            sp.Command.AddParameter("iWhoToo",iWhoToo,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_isundersourcecontrol_u(string vchLoginName,string vchPassword,int iWhoToo){
            StoredProcedure sp=new StoredProcedure("dt_isundersourcecontrol_u",this.Provider);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.String);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.String);
            sp.Command.AddParameter("iWhoToo",iWhoToo,DbType.Int32);
            return sp;
        }
        public StoredProcedure dt_removefromsourcecontrol(){
            StoredProcedure sp=new StoredProcedure("dt_removefromsourcecontrol",this.Provider);
            return sp;
        }
        public StoredProcedure dt_setpropertybyid(int id,string property,string value,byte[] lvalue){
            StoredProcedure sp=new StoredProcedure("dt_setpropertybyid",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            sp.Command.AddParameter("value",value,DbType.AnsiString);
            sp.Command.AddParameter("lvalue",lvalue,DbType.Binary);
            return sp;
        }
        public StoredProcedure dt_setpropertybyid_u(int id,string property,string uvalue,byte[] lvalue){
            StoredProcedure sp=new StoredProcedure("dt_setpropertybyid_u",this.Provider);
            sp.Command.AddParameter("id",id,DbType.Int32);
            sp.Command.AddParameter("property",property,DbType.AnsiString);
            sp.Command.AddParameter("uvalue",uvalue,DbType.String);
            sp.Command.AddParameter("lvalue",lvalue,DbType.Binary);
            return sp;
        }
        public StoredProcedure dt_validateloginparams(string vchLoginName,string vchPassword){
            StoredProcedure sp=new StoredProcedure("dt_validateloginparams",this.Provider);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.AnsiString);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_validateloginparams_u(string vchLoginName,string vchPassword){
            StoredProcedure sp=new StoredProcedure("dt_validateloginparams_u",this.Provider);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.String);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.String);
            return sp;
        }
        public StoredProcedure dt_vcsenabled(){
            StoredProcedure sp=new StoredProcedure("dt_vcsenabled",this.Provider);
            return sp;
        }
        public StoredProcedure dt_verstamp006(){
            StoredProcedure sp=new StoredProcedure("dt_verstamp006",this.Provider);
            return sp;
        }
        public StoredProcedure dt_verstamp007(){
            StoredProcedure sp=new StoredProcedure("dt_verstamp007",this.Provider);
            return sp;
        }
        public StoredProcedure dt_whocheckedout(string chObjectType,string vchObjectName,string vchLoginName,string vchPassword){
            StoredProcedure sp=new StoredProcedure("dt_whocheckedout",this.Provider);
            sp.Command.AddParameter("chObjectType",chObjectType,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("vchObjectName",vchObjectName,DbType.AnsiString);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.AnsiString);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure dt_whocheckedout_u(string chObjectType,string vchObjectName,string vchLoginName,string vchPassword){
            StoredProcedure sp=new StoredProcedure("dt_whocheckedout_u",this.Provider);
            sp.Command.AddParameter("chObjectType",chObjectType,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("vchObjectName",vchObjectName,DbType.String);
            sp.Command.AddParameter("vchLoginName",vchLoginName,DbType.String);
            sp.Command.AddParameter("vchPassword",vchPassword,DbType.String);
            return sp;
        }
        public StoredProcedure pr_check_login(string msnv,string password){
            StoredProcedure sp=new StoredProcedure("pr_check_login",this.Provider);
            sp.Command.AddParameter("msnv",msnv,DbType.AnsiString);
            sp.Command.AddParameter("password",password,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure pr_del_KH(decimal MSKH){
            StoredProcedure sp=new StoredProcedure("pr_del_KH",this.Provider);
            sp.Command.AddParameter("MSKH",MSKH,DbType.Decimal);
            return sp;
        }
        public StoredProcedure pr_del_LoaiPhong(string MSLOAIPHONG){
            StoredProcedure sp=new StoredProcedure("pr_del_LoaiPhong",this.Provider);
            sp.Command.AddParameter("MSLOAIPHONG",MSLOAIPHONG,DbType.AnsiStringFixedLength);
            return sp;
        }
        public StoredProcedure pr_del_NhanVien(string MSNV){
            StoredProcedure sp=new StoredProcedure("pr_del_NhanVien",this.Provider);
            sp.Command.AddParameter("MSNV",MSNV,DbType.AnsiStringFixedLength);
            return sp;
        }
        public StoredProcedure pr_del_Phong(string msPhong){
            StoredProcedure sp=new StoredProcedure("pr_del_Phong",this.Provider);
            sp.Command.AddParameter("msPhong",msPhong,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure pr_del_TBTrangTB(string MSLOAIPHONG,string MSTB){
            StoredProcedure sp=new StoredProcedure("pr_del_TBTrangTB",this.Provider);
            sp.Command.AddParameter("MSLOAIPHONG",MSLOAIPHONG,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("MSTB",MSTB,DbType.AnsiStringFixedLength);
            return sp;
        }
        public StoredProcedure pr_del_THIETBI_DV(string MSTB){
            StoredProcedure sp=new StoredProcedure("pr_del_THIETBI_DV",this.Provider);
            sp.Command.AddParameter("MSTB",MSTB,DbType.AnsiStringFixedLength);
            return sp;
        }
        public StoredProcedure pr_del_THUEPHONG(decimal SOHDONGTHUEPHONG){
            StoredProcedure sp=new StoredProcedure("pr_del_THUEPHONG",this.Provider);
            sp.Command.AddParameter("SOHDONGTHUEPHONG",SOHDONGTHUEPHONG,DbType.Decimal);
            return sp;
        }
        public StoredProcedure pr_ins_CHITIETTHUEPHONG(string option,decimal SOHDONGTHUEPHONG,decimal MSKH,string VAITRO){
            StoredProcedure sp=new StoredProcedure("pr_ins_CHITIETTHUEPHONG",this.Provider);
            sp.Command.AddParameter("option",option,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("SOHDONGTHUEPHONG",SOHDONGTHUEPHONG,DbType.Decimal);
            sp.Command.AddParameter("MSKH",MSKH,DbType.Decimal);
            sp.Command.AddParameter("VAITRO",VAITRO,DbType.AnsiStringFixedLength);
            return sp;
        }
        public StoredProcedure pr_ins_HDThanhToan(decimal SOHDONGTHUEPHONG,string MSNV,DateTime NGAYTHANHTOAN,decimal TIENPHONG){
            StoredProcedure sp=new StoredProcedure("pr_ins_HDThanhToan",this.Provider);
            sp.Command.AddParameter("SOHDONGTHUEPHONG",SOHDONGTHUEPHONG,DbType.Decimal);
            sp.Command.AddParameter("MSNV",MSNV,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("NGAYTHANHTOAN",NGAYTHANHTOAN,DbType.DateTime);
            sp.Command.AddParameter("TIENPHONG",TIENPHONG,DbType.Currency);
            return sp;
        }
        public StoredProcedure pr_ins_KH(decimal MSKH,string HOTENKH,bool GIOITINHKH,string DIACHIKH,string CMND,string DIENTHOAIKH){
            StoredProcedure sp=new StoredProcedure("pr_ins_KH",this.Provider);
            sp.Command.AddParameter("MSKH",MSKH,DbType.Decimal);
            sp.Command.AddParameter("HOTENKH",HOTENKH,DbType.String);
            sp.Command.AddParameter("GIOITINHKH",GIOITINHKH,DbType.Boolean);
            sp.Command.AddParameter("DIACHIKH",DIACHIKH,DbType.String);
            sp.Command.AddParameter("CMND",CMND,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("DIENTHOAIKH",DIENTHOAIKH,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure pr_ins_LoaiPhong(string MSLOAIPHONG,string TENLOAIPHONG,decimal GIATIEN){
            StoredProcedure sp=new StoredProcedure("pr_ins_LoaiPhong",this.Provider);
            sp.Command.AddParameter("MSLOAIPHONG",MSLOAIPHONG,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("TENLOAIPHONG",TENLOAIPHONG,DbType.String);
            sp.Command.AddParameter("GIATIEN",GIATIEN,DbType.Currency);
            return sp;
        }
        public StoredProcedure pr_ins_NV(bool option,string MSNV,string HOTENNV,string MatKhau,DateTime NGAYSINHNV,bool GIOITINHNV,string DIACHINV,string DIENTHOAINV,DateTime NGAYVAOLAM,string HINH){
            StoredProcedure sp=new StoredProcedure("pr_ins_NV",this.Provider);
            sp.Command.AddParameter("option",option,DbType.Boolean);
            sp.Command.AddParameter("MSNV",MSNV,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("HOTENNV",HOTENNV,DbType.String);
            sp.Command.AddParameter("MatKhau",MatKhau,DbType.AnsiString);
            sp.Command.AddParameter("NGAYSINHNV",NGAYSINHNV,DbType.DateTime);
            sp.Command.AddParameter("GIOITINHNV",GIOITINHNV,DbType.Boolean);
            sp.Command.AddParameter("DIACHINV",DIACHINV,DbType.String);
            sp.Command.AddParameter("DIENTHOAINV",DIENTHOAINV,DbType.AnsiString);
            sp.Command.AddParameter("NGAYVAOLAM",NGAYVAOLAM,DbType.DateTime);
            sp.Command.AddParameter("HINH",HINH,DbType.AnsiString);
            return sp;
        }
        public StoredProcedure pr_ins_Phong(string MSPHONG,string MSLOAIPHONG,string TINHTRANG){
            StoredProcedure sp=new StoredProcedure("pr_ins_Phong",this.Provider);
            sp.Command.AddParameter("MSPHONG",MSPHONG,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("MSLOAIPHONG",MSLOAIPHONG,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("TINHTRANG",TINHTRANG,DbType.AnsiStringFixedLength);
            return sp;
        }
        public StoredProcedure pr_ins_SuDung_DV(string option,decimal SOHDONGTHUEPHONG,string MSTB,DateTime NGAYSD,int SOLUONG){
            StoredProcedure sp=new StoredProcedure("pr_ins_SuDung_DV",this.Provider);
            sp.Command.AddParameter("option",option,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("SOHDONGTHUEPHONG",SOHDONGTHUEPHONG,DbType.Decimal);
            sp.Command.AddParameter("MSTB",MSTB,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("NGAYSD",NGAYSD,DbType.DateTime);
            sp.Command.AddParameter("SOLUONG",SOLUONG,DbType.Int32);
            return sp;
        }
        public StoredProcedure pr_ins_TBTrangTB(string MSLOAIPHONG,string MSTB,decimal SOLUONG){
            StoredProcedure sp=new StoredProcedure("pr_ins_TBTrangTB",this.Provider);
            sp.Command.AddParameter("MSLOAIPHONG",MSLOAIPHONG,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("MSTB",MSTB,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("SOLUONG",SOLUONG,DbType.Decimal);
            return sp;
        }
        public StoredProcedure pr_ins_THIETBI_DV(string MSTB,string TENTHIETBI,string DVT,decimal GIATB,string THIETBICODINH){
            StoredProcedure sp=new StoredProcedure("pr_ins_THIETBI_DV",this.Provider);
            sp.Command.AddParameter("MSTB",MSTB,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("TENTHIETBI",TENTHIETBI,DbType.String);
            sp.Command.AddParameter("DVT",DVT,DbType.String);
            sp.Command.AddParameter("GIATB",GIATB,DbType.Currency);
            sp.Command.AddParameter("THIETBICODINH",THIETBICODINH,DbType.AnsiStringFixedLength);
            return sp;
        }
        public StoredProcedure pr_ins_THUEPHONG(string option,decimal SOHDONGTHUEPHONG,string MSNV,string MSPHONG,DateTime NGAYTHUE,DateTime NGAYTRADK){
            StoredProcedure sp=new StoredProcedure("pr_ins_THUEPHONG",this.Provider);
            sp.Command.AddParameter("option",option,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("SOHDONGTHUEPHONG",SOHDONGTHUEPHONG,DbType.Decimal);
            sp.Command.AddParameter("MSNV",MSNV,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("MSPHONG",MSPHONG,DbType.AnsiStringFixedLength);
            sp.Command.AddParameter("NGAYTHUE",NGAYTHUE,DbType.DateTime);
            sp.Command.AddParameter("NGAYTRADK",NGAYTRADK,DbType.DateTime);
            return sp;
        }
        public StoredProcedure pr_list_KH(){
            StoredProcedure sp=new StoredProcedure("pr_list_KH",this.Provider);
            return sp;
        }
        public StoredProcedure pr_list_KHSearch(){
            StoredProcedure sp=new StoredProcedure("pr_list_KHSearch",this.Provider);
            return sp;
        }
        public StoredProcedure pr_list_LoaiPhong(){
            StoredProcedure sp=new StoredProcedure("pr_list_LoaiPhong",this.Provider);
            return sp;
        }
        public StoredProcedure pr_list_NV(){
            StoredProcedure sp=new StoredProcedure("pr_list_NV",this.Provider);
            return sp;
        }
        public StoredProcedure pr_list_NV_by_MANV(string MANV){
            StoredProcedure sp=new StoredProcedure("pr_list_NV_by_MANV",this.Provider);
            sp.Command.AddParameter("MANV",MANV,DbType.AnsiStringFixedLength);
            return sp;
        }
        public StoredProcedure pr_list_Phong(){
            StoredProcedure sp=new StoredProcedure("pr_list_Phong",this.Provider);
            return sp;
        }
        public StoredProcedure pr_list_Phong_trong(){
            StoredProcedure sp=new StoredProcedure("pr_list_Phong_trong",this.Provider);
            return sp;
        }
        public StoredProcedure pr_list_PhongSearch(){
            StoredProcedure sp=new StoredProcedure("pr_list_PhongSearch",this.Provider);
            return sp;
        }
        public StoredProcedure pr_list_SuDungDV(decimal SOHDONGTHUEPHONG){
            StoredProcedure sp=new StoredProcedure("pr_list_SuDungDV",this.Provider);
            sp.Command.AddParameter("SOHDONGTHUEPHONG",SOHDONGTHUEPHONG,DbType.Decimal);
            return sp;
        }
        public StoredProcedure pr_list_TBTrangThietBi(){
            StoredProcedure sp=new StoredProcedure("pr_list_TBTrangThietBi",this.Provider);
            return sp;
        }
        public StoredProcedure pr_list_ThietBi(){
            StoredProcedure sp=new StoredProcedure("pr_list_ThietBi",this.Provider);
            return sp;
        }
        public StoredProcedure pr_Phong_KH(string msphong){
            StoredProcedure sp=new StoredProcedure("pr_Phong_KH",this.Provider);
            sp.Command.AddParameter("msphong",msphong,DbType.AnsiStringFixedLength);
            return sp;
        }
	
	}
	
}
 